2013-04-03 - 5834.1000 - Service Request- Consolidated Invoices #FISD

Sai Valisetti - 2013-04-03 - 5834.1000 - Service Request- Consolidated Invoices

Problem Summary

Determine solution to provide consolidated invoices to meet vendor compliance requests for Mexico, Russia and Canada.

The biggest risk is that the FI items for Revenue and discount cannot be summarized by profit center. Currently, each schedule line (size) in the document has one item, we will need to summarize the revenue and discount items in FI for one item per profit center.

Admin Info


Purpose
 Consolidated Invoices
Requested by
 Jingsha Brennon
Issue Date
 04/11/2013
Resolved by
 Sai Valisetti
Resolved Date
 04/19/2013
Document Status
 Completed

Detailed Problem Description

(Include Screen Shots if required )

Jingsha have tried to configured the FI summarization in OBCY, however, after the configuration, the revenue and discount items are still not summarized, while royalty and commissions are summarized. I have added all the possible fields in V_TTYPS and V_TTYPV for object type VBRK, that did not resolve the problem.

Need to reverse the configurations I have done in V_TTYPS and in V_TTYPV. However, since I have include all possible entries in those two tables, it seems to me that we cannot achieve our goal to summarize FI items through this configuration for Revenue and discount. Could you look into the issue and let us know your thoughts?

When table V_TTYPV was left blank, below is what it looks like in the accounting document for an invoice(90009726 in NED300) :

After config in Commission and Royalty are summarized, but not revenue and discount (Revenue and discount are summarized to certain level, but not enough for consolidated invoice purpose, example 90010141 in NED300).




Solution Analysis and Recommendations
(Include Screen Shots if required)
FI documents generated from the SD billing are already summarized in PRD. It summarizes Revenues, discounts, commissions and royalties.
It won’t summarize for the following cases.

  1. 1. If the Tax related line Items are in Revenues, discounts, commissions and royalties.
  2. 2. If the profit centers are different for two different materials.
  3. 3. It won’t summarize if the plants are different.

You can validate all the below billing documents that don’t have the taxes and does the summarization:
Company code 0010: 91578934, 91578933, 91539048, 91539049, 91534806, 91497903, 91469332
Company code 0028: 91442873, 91450481, 91509342, 91537687, 91564170, 91579709.
Company code 0020: 91590652, 91592197, 91577882, 91565938, 91554996

The examples we have it below with Tax code A0 for revenues and other ones does not have the taxes that is why it could not summarize those.

To summarize the tax, we have to look in to the OSS notes Note 85982 - Summarizing the tax line items from SD … but I do not think this is valid for 6.0 version.
For ECC 6.0 if we add the Tax field in VBRK it will through the error in rest of the SD applications so we don’t want to add that field, and also adding that field does not serve the purpose of summarizing Tax.. but it deletes the tax in the line items(We Do not want to delete the tax in the billing document revenues).

Summarization is a high risk process because it deletes the data permanently and we cannot recover them back once it is deleted in the tables and so we need to be very very cautious adding any new fields to V_TTYPS and in V_TTYPV, if we add all the fields it will deletes the data in all the fields and many BI and other finance reports that use them they would not have the data.

Summarization of Tax Items.doc

Resolution

Jingsha passed the request to SAP.

Release Information

Provide link here to Release Notes if Technical Objects were changed